-----------------------------------------------------
--created:Son nguyen van
--created_date:03/04/2013
--desc: view product full
create view v_product
as
	select a.product_id,a.product_code,
		   a.product_status,a.created_date,
		   a.modify_date,a.modify_by,
		   a.quantity,a.price,
		   a.old_price,a.images,
		   a.tax,a.sales,
		   b.product_item_id,
		   b.product_name,b.product_alias,
		   b.product_desc_short,b.product_desc,
		   b.product_features,b.product_title,
		   b.product_meta_keyword,b.product_meta_description,
		   b.product_item_enable,b.language_id,
		   c.category_id,
		   d.category_param	   
	from tbl_product a left outer join tbl_product_item b on a.product_id = b.product_item_id
					   left outer join tbl_product_ref_category c on  a.product_id = c.product_id
					   left outer join tbl_product_category d on c.category_id = d.category_id
go


